UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'is4snoMSRkJ6tC6DJYTj0iWPjlR7uafrLPUkqU/JpfI='
WHERE
key_id = '4168a20b5f45a76526a58e4f10416f81160af65e5a2406c666974ddb51985ee4'
AND (
token = 'is4snoMSRkJ6tC6DJYTj0iWPjlR7uafrLPUkqU/JpfI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)