UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '47YWqzb2uCNVLVYJTNS1/Oy4YY7ijw/aqAA2BwpPGZg='
WHERE
key_id = '9d997ca84872b4218902208968bff36f5840e7b2620d6409f066d2f3a09bad2c'
AND (
token = '47YWqzb2uCNVLVYJTNS1/Oy4YY7ijw/aqAA2BwpPGZg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)