UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hvZgikDmfWE3heTNWPjqP2ywbwOlH6IE+IgR4XYTVTY='
WHERE
key_id = '173018f31b45b50187d265868bc120e87734483f8df266e60e8aaaa5b6aa971a'
AND (
token = 'hvZgikDmfWE3heTNWPjqP2ywbwOlH6IE+IgR4XYTVTY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)