UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qPJP7Xni0DPYzxQdY/yomN+3Rbb0coS9Kht+2TbJW/M='
WHERE
key_id = '9ba135363346f033c07eb5aeff3b08c1a996b17513c49d8f3fd1387b53b48543'
AND (
token = 'qPJP7Xni0DPYzxQdY/yomN+3Rbb0coS9Kht+2TbJW/M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)