UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z37kguZJXLjU7Q20J4Beg3qIfuHfuJk23KrDzrWwBFE='
WHERE
key_id = '823553ebf31e0802785d8015198c9751e088a9ffe6f0ad59f2622445c273fa2c'
AND (
token = 'z37kguZJXLjU7Q20J4Beg3qIfuHfuJk23KrDzrWwBFE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)