UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E8gXBtCQsHxMT9cDUUyPczXfbFOdwQ2cee2yvtyLcA0='
WHERE
key_id = '916067f72431a40b2ea0e3748fb4aac79b821e5b291b095c4d94d8055c914eca'
AND (
token = 'E8gXBtCQsHxMT9cDUUyPczXfbFOdwQ2cee2yvtyLcA0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)