UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xi0L3ccfWTdjd5klDs3yTWj81rlgK6ZAXCgTStst+Cg='
WHERE
key_id = 'c8bc522b50941e1d5feb386fbf0ad5f282b6df5179b8d3186f443f4551d4284e'
AND (
token = 'xi0L3ccfWTdjd5klDs3yTWj81rlgK6ZAXCgTStst+Cg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)