UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zfteb007YNHOBaz6ZjmIrtgv33qbOIE8kWKfsKD4M6g='
WHERE
key_id = '5d41fec25f47787b7875e6c951622f6065ebc1f1f7a5e70e29a3aa2591a6f20f'
AND (
token = 'Zfteb007YNHOBaz6ZjmIrtgv33qbOIE8kWKfsKD4M6g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)