UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ufreumpX+j2QS/ezTN+uN95zCyc1asoZ2tmbRE0uPlw='
WHERE
key_id = '8bb1869acf6a0125b80bd89770b79ab36b43284468723585cd191efab9b13e57'
AND (
token = 'ufreumpX+j2QS/ezTN+uN95zCyc1asoZ2tmbRE0uPlw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)