UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'olFye1JZap0701N43GBzLF4I802gugkrf1p4IDSydf0='
WHERE
key_id = '175a77c0f093871b3b66f293569417668ba6e17b8f919e72c90e097634dc860e'
AND (
token = 'olFye1JZap0701N43GBzLF4I802gugkrf1p4IDSydf0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)