UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '46WmyHZLw5dh0XBcoyLs4unMC6nPMI+gg0mdQjhLWb8='
WHERE
key_id = 'd0954cdba2d18be38e118f8959e1462c37c2cf2c3c098b452f8f148f30d094bf'
AND (
token = '46WmyHZLw5dh0XBcoyLs4unMC6nPMI+gg0mdQjhLWb8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)