UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/N5p9mWl4L3t5iSH1TN1hN7TZy0ycejYsSakTBA8My8='
WHERE
key_id = 'd38bd1cb9b0dac65e68686295aed3a83b3b9f08659db47bb6196b68d22af1db6'
AND (
token = '/N5p9mWl4L3t5iSH1TN1hN7TZy0ycejYsSakTBA8My8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)