UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5k8XTkdKihUhwYoitw2j6jKQe8RxE6J+4Mse32V3bDo='
WHERE
key_id = 'ea3ca7c3fa1f8c82eebd1f72c32b55329bace3ea1bc17211393d478a9818db5e'
AND (
token = '5k8XTkdKihUhwYoitw2j6jKQe8RxE6J+4Mse32V3bDo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)