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