UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd1YlW4nq8Fr6+HvpcMyBCywbS7Mm24Wvhoztm60EiB0='
WHERE
key_id = '04607bb30eadb6cfb8f3b82cdd1c3b81d161d7ece4bc00227c08348864e4f8dc'
AND (
token = 'd1YlW4nq8Fr6+HvpcMyBCywbS7Mm24Wvhoztm60EiB0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)