UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TY1repmG43QYTTXPu7JLX/BFTNFnFRghZLquWDKtueE='
WHERE
key_id = 'f277aa89029f0a97a2798f4b6c87d8ab85b4a602617cdde4c06048c05be80073'
AND (
token = 'TY1repmG43QYTTXPu7JLX/BFTNFnFRghZLquWDKtueE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)