UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0UKCjniXlW1KvMMFQiqy3ELY/A6IN1BwDwjTVSimeLc='
WHERE
key_id = 'f1eaa2c47f032191c3b40b3de61277e8638828069802e4d27995285db6f0130b'
AND (
token = '0UKCjniXlW1KvMMFQiqy3ELY/A6IN1BwDwjTVSimeLc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)