UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rnAhPp3Uhv4aZRtvlnULvw+E+eI2WU+OC6WptnNlTCM='
WHERE
key_id = '6fc5bdf5327c62a7a016ec900819a05d78b5e99b4a4e784a6a5f63ee1b8abcd2'
AND (
token = 'rnAhPp3Uhv4aZRtvlnULvw+E+eI2WU+OC6WptnNlTCM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)