UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nqVjzdAy/+OLNTwSP79LETwB39cNShMOol6g/j9cum0='
WHERE
key_id = 'd1cf111c3cecb703422cb36ba99babb728a337c5d0ecc4a5ebb1923397d4d4fc'
AND (
token = 'nqVjzdAy/+OLNTwSP79LETwB39cNShMOol6g/j9cum0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)