UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P223SqUJ/iSiuK95HHiTFRFEmHwP6ubZzZt2hsSyu1E='
WHERE
key_id = '8b8e999699865a5c9d5de9e297fb1478813e3405245f45599edb900be617272f'
AND (
token = 'P223SqUJ/iSiuK95HHiTFRFEmHwP6ubZzZt2hsSyu1E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)