UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yLXwl0kNZpCUADqbRv3stHVchOciw36Xf0Z7dGuAWQo='
WHERE
key_id = 'b996c1c780304f7855798a80cab1ae6c5918fee3588ddbca3a34c3466fa37d93'
AND (
token = 'yLXwl0kNZpCUADqbRv3stHVchOciw36Xf0Z7dGuAWQo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)