UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Mcdoa6zJpWC3cBZLgL2nawsgOuSaNQNsnjViEAW0Agw='
WHERE
key_id = '1d6251a103c36eba7da5ca17bdfdd72f375b492473ec223037b28b94b31d23eb'
AND (
token = 'Mcdoa6zJpWC3cBZLgL2nawsgOuSaNQNsnjViEAW0Agw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)