UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tHiV3Ylbpj0tn6ZISSSZjIkrpEt2xHPIOeU5jOqXKUg='
WHERE
key_id = '0d9de71534818b72e8d248fe9e4012ff9a426dc767418f7793b3da9445f047ee'
AND (
token = 'tHiV3Ylbpj0tn6ZISSSZjIkrpEt2xHPIOeU5jOqXKUg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)