UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T2CGUXNJhI89aaprimFeb3olohre+oVVxubBzGeKL8E='
WHERE
key_id = 'bd3db86597489e3b9b13a099a54673703721c6faa91a08cf6c6ac46dab1d7ddf'
AND (
token = 'T2CGUXNJhI89aaprimFeb3olohre+oVVxubBzGeKL8E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)