UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tIRhs2OLd89L93KqzsI0wV4CbJxkc1Pg7yhFTEVo3Tk='
WHERE
key_id = 'a2c785f674286ad226fe53e643e37e2a9411f48eeed2184c3b318043fcdd1548'
AND (
token = 'tIRhs2OLd89L93KqzsI0wV4CbJxkc1Pg7yhFTEVo3Tk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)