UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CUx1SWX7Jdab3JhGNrkkeFnq6sERMy6t93SWHF2cTjo='
WHERE
key_id = '3be28492891c07499807476b96f54b08481adae31bb980c82d8daa1506dad72e'
AND (
token = 'CUx1SWX7Jdab3JhGNrkkeFnq6sERMy6t93SWHF2cTjo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)