UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zKmgXKYKMIC2IhGloTeVzOv6oIoIjG9eDPdJkTWqxx4='
WHERE
key_id = '52a1fd55ceced94766de4a1dcff4d99a55fa69c8d7b5480922aef38f51d98ebd'
AND (
token = 'zKmgXKYKMIC2IhGloTeVzOv6oIoIjG9eDPdJkTWqxx4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)