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