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